<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');

class Countries extends CI_Model {

	function __construct() {
        parent::__construct();
    }

    public function getAll() {
    	$sql = "SELECT " .
			   "c.CountryId AS `Id`, " .
			   "c.Country " .
			   "FROM " .
			   "countries AS c " .
			   "ORDER BY " .
			   "c.Country";

		$query = $this->db->query($sql);
		return $query->result_array();
    }
}